* Created: 6/12/2004 11:30:25 PM
*                                                        
* Modify the path below to point to your data file.      
* The specified subdirectory was not created on          
* your computer. You will need to do this.               
*                                                        
* The stat program must be run against the specified     
* data file. This file is specified in the program       
* and must be saved separately.                          
*                                                        
* This program does not provide tab or summarize for all 
* variables.                                             
*                                                        
* There may be missing data for some institutions due    
* to the merge used to create this file.                 
*                                                        
* This program does not include reserved values in its   
* calculations for missing values.                       
*                                                        
* You may need to adjust your memory settings depending  
* upon the number of variables and records.              
*                                                        
* The save command may need to be modified per user      
* requirements.                                          
*                                                        
* For long lists of value labels, the titles may be      
* shortened per program requirements. 
*                                                        
insheet using ic99_hd_data_stata.csv, comma clear
*label data "dct_ic99_hd"
label variable unitid "unitid"
label variable form_ic "Survey form"
label variable stat_ic "Response status of the institution"
label variable stat_pte "IC response status"
label variable prch_ic "Parent/Child indicator"
label variable idx_ic "UNITID of parent institution reporting full-year enrollment"
label variable imp_ic "Impute status of the institution"
label variable cyactive "Institution is active in current year"
label variable closedat "Date institution closed"
label variable addr "Street address or post office box"
label variable city "City location of institution"
label variable stabbr "Post Office State abbreviation code"
label variable zip "ZIP + four"
label variable countynm "County name"
label variable cntygeo "3-digit county fips code"
label variable fips "FIPS State code"
label variable obereg "OBE region code"
label variable chfnm "Name of Chief Administrator"
label variable chftitle "Title of Chief Administrator"
label variable gentele "General information telephone number"
label variable fintele "Financial Aid Office telephone number"
label variable admtele "Admissions office telephone number"
label variable ein "Employer Identification Number"
label variable duns "Dunn and Bradstreet identification number"
label variable opeid "Office of Postsecondary Education ID"
label variable opeflag "OPE eligibility indicator code"
label variable webaddr "Institution^s internet website address"
label variable refu_ic "Refusal status of the institution"
label variable src_ic "Medium used to collect data"
label variable edit_ic "Edit status of the institution"
label variable date_ic "Date last edited or imputed"
label variable sector "Sector of institution"
label variable iclevel "Level of institution"
label variable control "Control of institution"
label variable affil "Affiliation of institution"
label variable hloffer "Highest level of offering"
label variable ugoffer "Undergraduate offering"
label variable groffer "Graduate offering"
label variable fpoffer "First-professional offering"
label variable hdegoffr "Highest Degree offered"
label variable pctmin1 "Percent Black, non-Hispanic"
label variable pctmin2 "Percent American Indian/Alaskan Native"
label variable pctmin3 "Percent Asian/Pacific Islander"
label variable pctmin4 "Percent Hispanic"
label variable hbcu "Historically Black College or University"
label variable hospital "Institution has hospital"
label variable medical "Institution grants a medical degree"
label variable tribal "Tribal college"
label variable carnegie "Carnegie Classification Code"
label variable locale "Degree of Urbanization"
label variable act "Status of institution"
label variable newid "UNITID for merged schools"
label variable deathyr "Year institution was deleted from IPEDS"
label define label_form_ic 1 "4- & 2-year inst & <2-yr public" 
label define label_form_ic 15 "Institution added during current year", add 
label define label_form_ic 3 "Private less-than-2-year institution", add 
label values form_ic label_form_ic
label define label_stat_ic 1 "Mailed, response" 
label define label_stat_ic 3 "Mailed, nonresponse, not imputed", add 
label values stat_ic label_stat_ic
label define label_stat_pte 1 "Mailed, Part E response" 
label define label_stat_pte 3 "Mailed, Part E nonresponse, not imputed", add 
label values stat_pte label_stat_pte
label define label_prch_ic -2 "{Item not applicable}" 
label define label_prch_ic 1 "Parent record (combined data)", add 
label define label_prch_ic 2 "Child record (reported with parent)", add 
label values prch_ic label_prch_ic
label define label_closedat -2 "{Item not applicable}" 
*label define label_closedat Alpha "{Alpha}", add 
*label values closedat label_closedat
/*label define label_stabbr AK "Alaska" 
label define label_stabbr AL "Alabama", add 
label define label_stabbr AR "Arkansas", add 
label define label_stabbr AS "American Samoa", add 
label define label_stabbr AZ "Arizona", add 
label define label_stabbr CA "California", add 
label define label_stabbr CO "Colorado", add 
label define label_stabbr CT "Connecticut", add 
label define label_stabbr DC "District of Columbia", add 
label define label_stabbr DE "Delaware", add 
label define label_stabbr FL "Florida", add 
label define label_stabbr FM "Federated States of Micronesia", add 
label define label_stabbr GA "Georgia", add 
label define label_stabbr GU "Guam", add 
label define label_stabbr HI "Hawaii", add 
label define label_stabbr IA "Iowa", add 
label define label_stabbr ID "Idaho", add 
label define label_stabbr IL "Illinois", add 
label define label_stabbr IN "Indiana", add 
label define label_stabbr KS "Kansas", add 
label define label_stabbr KY "Kentucky", add 
label define label_stabbr LA "Louisiana", add 
label define label_stabbr MA "Massachusetts", add 
label define label_stabbr MD "Maryland", add 
label define label_stabbr ME "Maine", add 
label define label_stabbr MH "Marshall Islands", add 
label define label_stabbr MI "Michigan", add 
label define label_stabbr MN "Minnesota", add 
label define label_stabbr MO "Missouri", add 
label define label_stabbr MP "Northern Marianas", add 
label define label_stabbr MS "Mississippi", add 
label define label_stabbr MT "Montana", add 
label define label_stabbr NC "North Carolina", add 
label define label_stabbr ND "North Dakota", add 
label define label_stabbr NE "Nebraska", add 
label define label_stabbr NH "New Hampshire", add 
label define label_stabbr NJ "New Jersey", add 
label define label_stabbr NM "New Mexico", add 
label define label_stabbr NV "Nevada", add 
label define label_stabbr NY "New York", add 
label define label_stabbr OH "Ohio", add 
label define label_stabbr OK "Oklahoma", add 
label define label_stabbr OR "Oregon", add 
label define label_stabbr PA "Pennsylvania", add 
label define label_stabbr PR "Puerto Rico", add 
label define label_stabbr PW "Palau", add 
label define label_stabbr RI "Rhode Island", add 
label define label_stabbr SC "South Carolina", add 
label define label_stabbr SD "South Dakota", add 
label define label_stabbr TN "Tennessee", add 
label define label_stabbr TX "Texas", add 
label define label_stabbr UT "Utah", add 
label define label_stabbr VA "Virginia", add 
label define label_stabbr VI "Virgin Islands", add 
label define label_stabbr VT "Vermont", add 
label define label_stabbr WA "Washington", add 
label define label_stabbr WI "Wisconsin", add 
label define label_stabbr WV "West Virginia", add 
label define label_stabbr WY "Wyoming", add 
label values stabbr label_stabbr
label define label_countynm -1 "{Not reported}" 
label define label_countynm Alpha "{Alpha}", add 
label values countynm label_countynm*/
label define label_fips 1 "Alabama" 
label define label_fips 10 "Delaware", add 
label define label_fips 11 "District of Columbia", add 
label define label_fips 12 "Florida", add 
label define label_fips 13 "Georgia", add 
label define label_fips 15 "Hawaii", add 
label define label_fips 16 "Idaho", add 
label define label_fips 17 "Illinois", add 
label define label_fips 18 "Indiana", add 
label define label_fips 19 "Iowa", add 
label define label_fips 2 "Alaska", add 
label define label_fips 20 "Kansas", add 
label define label_fips 21 "Kentucky", add 
label define label_fips 22 "Louisiana", add 
label define label_fips 23 "Maine", add 
label define label_fips 24 "Maryland", add 
label define label_fips 25 "Massachusetts", add 
label define label_fips 26 "Michigan", add 
label define label_fips 27 "Minnesota", add 
label define label_fips 28 "Mississippi", add 
label define label_fips 29 "Missouri", add 
label define label_fips 30 "Montana", add 
label define label_fips 31 "Nebraska", add 
label define label_fips 32 "Nevada", add 
label define label_fips 33 "New Hampshire", add 
label define label_fips 34 "New Jersey", add 
label define label_fips 35 "New Mexico", add 
label define label_fips 36 "New York", add 
label define label_fips 37 "North Carolina", add 
label define label_fips 38 "North Dakota", add 
label define label_fips 39 "Ohio", add 
label define label_fips 4 "Arizona", add 
label define label_fips 40 "Oklahoma", add 
label define label_fips 41 "Oregon", add 
label define label_fips 42 "Pennsylvania", add 
label define label_fips 44 "Rhode Island", add 
label define label_fips 45 "South Carolina", add 
label define label_fips 46 "South Dakota", add 
label define label_fips 47 "Tennessee", add 
label define label_fips 48 "Texas", add 
label define label_fips 49 "Utah", add 
label define label_fips 5 "Arkansas", add 
label define label_fips 50 "Vermont", add 
label define label_fips 51 "Virginia", add 
label define label_fips 53 "Washington", add 
label define label_fips 54 "West Virginia", add 
label define label_fips 55 "Wisconsin", add 
label define label_fips 56 "Wyoming", add 
label define label_fips 6 "California", add 
label define label_fips 60 "American Samoa", add 
label define label_fips 64 "Federated States of Micronesia", add 
label define label_fips 66 "Guam", add 
label define label_fips 68 "Marshall Islands", add 
label define label_fips 69 "Northern Marianas", add 
label define label_fips 70 "Palau", add 
label define label_fips 72 "Puerto Rico", add 
label define label_fips 78 "Virgin Islands", add 
label define label_fips 8 "Colorado", add 
label define label_fips 9 "Connecticut", add 
label values fips label_fips
label define label_obereg 0 "US Service schools" 
label define label_obereg 1 "New England CT ME MA NH RI VT", add 
label define label_obereg 2 "Mid East DE DC MD NJ NY PA", add 
label define label_obereg 3 "Great Lakes IL IN MI OH WI", add 
label define label_obereg 4 "Plains IA KS MN MO NE ND SD", add 
label define label_obereg 5 "AL AR FL GA KY LA MS NC SC TN VA WV", add 
label define label_obereg 6 "Southwest AZ NM OK TX", add 
label define label_obereg 7 "Rocky Mountains CO ID MT UT WY", add 
label define label_obereg 8 "Far West AK CA HI NV OR WA", add 
label define label_obereg 9 "Outlying areas AS FM GU MH MP PR PW VI", add 
label values obereg label_obereg
/*label define label_chfnm -1 "{Not reported}" 
*label define label_chfnm Alpha "{Alpha}", add 
label values chfnm label_chfnm
label define label_chftitle -1 "{Not reported}" 
*label define label_chftitle Alpha "{Alpha}", add 
label values chftitle label_chftitle
label define label_gentele -1 "{Not reported}" 
*label define label_gentele Alpha "{Alpha}", add 
label values gentele label_gentele
label define label_fintele -1 "{Not reported}" 
*label define label_fintele Alpha "{Alpha}", add 
label values fintele label_fintele
label define label_admtele -1 "{Not reported}" 
*label define label_admtele Alpha "{Alpha}", add 
label values admtele label_admtele*/
label define label_opeflag 1 "Eligible for Title IV aid" 
label define label_opeflag 2 "Branch campus not on Title IV file", add 
label define label_opeflag 3 "Eligible/Title IV aid, deferment only", add 
label define label_opeflag 4 "Eligible for Title IV aid, out-of-scope", add 
label define label_opeflag 5 "Not currently eligible for Title IV aid", add 
label define label_opeflag 6 "Not on Title IV file, and not eligible", add 
label values opeflag label_opeflag
label define label_refu_ic -2 "{Item not applicable}" 
label define label_refu_ic 1 "Refused to provide data", add 
label values refu_ic label_refu_ic
label define label_src_ic -2 "{Item not applicable}" 
label define label_src_ic 4 "Form", add 
label values src_ic label_src_ic
label define label_edit_ic -2 "{Item not applicable}" 
label define label_edit_ic 1 "Passed edits", add 
label define label_edit_ic 2 "Edit flags remain, analyst accepted", add 
label values edit_ic label_edit_ic
*label define label_date_ic -2 "{Item not applicable}" 
*label define label_date_ic Alpha "{Alpha}", add 
*label values date_ic label_date_ic
label define label_sector 0 "Administrative unit only" 
label define label_sector 1 "Public, 4-year or above", add 
label define label_sector 2 "Private nonprofit, 4-year or above", add 
label define label_sector 3 "Private for-profit, 4-year or above", add 
label define label_sector 4 "Public, 2-year", add 
label define label_sector 5 "Private nonprofit, 2-year", add 
label define label_sector 6 "Private for-profit, 2-year", add 
label define label_sector 7 "Public, less-than-2-year", add 
label define label_sector 8 "Private nonprofit, less-than-2-year", add 
label define label_sector 9 "Private for-profit, less-than-2-year", add 
label values sector label_sector
label define label_iclevel 1 "Four or more years" 
label define label_iclevel 2 "At least 2 but less than 4 years", add 
label define label_iclevel 3 "Less than 2 years (below associate)", add 
label values iclevel label_iclevel
label define label_control 1 "Public" 
label define label_control 2 "Private, nonprofit", add 
label define label_control 3 "Private, for-profit", add 
label values control label_control
label define label_affil 1 "Public" 
label define label_affil 2 "Private, for-profit", add 
label define label_affil 3 "Private, nonprofit, no religious affiliation", add 
label define label_affil 4 "Private, nonprofit", add 
label values affil label_affil
label define label_hloffer -2 "{Not applicable, first-professional only}" 
label define label_hloffer -3 "{Not available}", add 
label define label_hloffer 0 "Other", add 
label define label_hloffer 1 "Award of less than one academic year", add 
label define label_hloffer 2 "At least 1, but less than 2 academic yrs", add 
label define label_hloffer 3 "Associates degree", add 
label define label_hloffer 4 "At least 2, but less than 4 academic yrs", add 
label define label_hloffer 5 "Bachelors degree", add 
label define label_hloffer 6 "Postbaccalaureate certificate", add 
label define label_hloffer 7 "Masters degree", add 
label define label_hloffer 8 "Post-masters certificate", add 
label define label_hloffer 9 "Doctors degree", add 
label values hloffer label_hloffer
label define label_ugoffer -3 "{Not available}" 
label define label_ugoffer 1 "Undergraduate degree or certificate offering", add 
label define label_ugoffer 2 "No undergraduate offering", add 
label values ugoffer label_ugoffer
label define label_groffer -3 "{Not available}" 
label define label_groffer 1 "Graduate degree or certificate offering", add 
label define label_groffer 2 "No graduate offering", add 
label values groffer label_groffer
label define label_fpoffer -3 "{Not available}" 
label define label_fpoffer 1 "First-professional degree/certificate", add 
label define label_fpoffer 2 "No first-professional offering", add 
label values fpoffer label_fpoffer
label define label_hdegoffr 0 "Non-degree granting" 
label define label_hdegoffr 1 "First-professional only", add 
label define label_hdegoffr 10 "Doctoral", add 
label define label_hdegoffr 11 "Doctoral and first-professional", add 
label define label_hdegoffr 20 "Masters", add 
label define label_hdegoffr 21 "Masters and first-professional", add 
label define label_hdegoffr 30 "Bachelors", add 
label define label_hdegoffr 31 "Bachelors and first-professional", add 
label define label_hdegoffr 40 "Associates", add 
label values hdegoffr label_hdegoffr
label define label_hbcu 1 "Yes" 
label define label_hbcu 2 "No", add 
label values hbcu label_hbcu
label define label_hospital 1 "Yes" 
label define label_hospital 2 "No", add 
label values hospital label_hospital
label define label_medical 1 "Yes" 
label define label_medical 2 "No", add 
label values medical label_medical
label define label_tribal 1 "Yes" 
label define label_tribal 2 "No", add 
label values tribal label_tribal
label define label_carnegie -2 "{Item not applicable}" 
label define label_carnegie 11 "Research universities I", add 
label define label_carnegie 12 "Research universities II", add 
label define label_carnegie 13 "Doctoral universities I", add 
label define label_carnegie 14 "Doctoral universities II", add 
label define label_carnegie 21 "Masters comprehensive I", add 
label define label_carnegie 22 "Masters comprehensive II", add 
label define label_carnegie 31 "BA liberal arts colleges I", add 
label define label_carnegie 32 "Baccalaureate colleges II", add 
label define label_carnegie 40 "Associate of Arts colleges", add 
label define label_carnegie 51 "Theological seminaries", add 
label define label_carnegie 52 "Medical schools", add 
label define label_carnegie 53 "Other health profession schools", add 
label define label_carnegie 54 "Schools of engineering and technology", add 
label define label_carnegie 55 "Schools of business and management", add 
label define label_carnegie 56 "Schools of art, music, and design", add 
label define label_carnegie 57 "Schools of law", add 
label define label_carnegie 58 "Teachers colleges", add 
label define label_carnegie 59 "Other specialized institutions", add 
label define label_carnegie 60 "Tribal colleges", add 
label values carnegie label_carnegie
label define label_locale -3 "{Not available}" 
label define label_locale 1 "Large city", add 
label define label_locale 2 "Mid-size city", add 
label define label_locale 3 "Urban fringe of large city", add 
label define label_locale 4 "Urban fringe of mid-size city", add 
label define label_locale 5 "Large town", add 
label define label_locale 6 "Small town", add 
label define label_locale 7 "Rural", add 
label define label_locale 9 "Not assigned", add 
label values locale label_locale
/*label define label_act A "Active - institution active and not an add" 
label define label_act M "Death with data - closed in current yr", add 
label define label_act N "New - added during the current year", add 
label define label_act R "Restore - restored to the current universe", add 
label define label_act S "Split - split into more than one institution", add 
label define label_act Z "Universe III - out-of-scope", add 
label values act label_act
tab form_ic
tab stat_ic
tab stat_pte
tab prch_ic
tab imp_ic
tab cyactive
tab stabbr
tab fips
tab obereg
tab opeflag
tab refu_ic
tab src_ic
tab edit_ic
tab sector
tab iclevel
tab control
tab affil
tab hloffer
tab ugoffer
tab groffer
tab fpoffer
tab hdegoffr
tab hbcu
tab hospital
tab medical
tab tribal
tab carnegie
tab locale
tab act
tab newid
tab deathyr
summarize idx_ic
summarize cntygeo
summarize pctmin1
summarize pctmin2
summarize pctmin3
summarize pctmin4


